USE [geshi]
GO

/****** Object:  Table [dbo].[person_tax]    Script Date: 01/08/2019 23:49:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[person_tax](
	[id] [bigint] IDENTITY(1,1) NOT NULL,
	[openid] [nvarchar](50) NULL,
	[id_card] [nvarchar](50) NULL,
	[passport] [nvarchar](50) NULL,
	[children_education] [nvarchar](50) NULL,
	[rent_hourse] [nvarchar](50) NULL,
	[hourse_loan] [nvarchar](50) NULL,
	[solatium] [nvarchar](50) NULL,
	[continuing_education] [nvarchar](50) NULL,
	[sum] [int] NULL,
	[medical_illness] [nvarchar](50) NULL
) ON [PRIMARY]

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'子女教育支出' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'person_tax', @level2type=N'COLUMN',@level2name=N'children_education'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'租房支出' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'person_tax', @level2type=N'COLUMN',@level2name=N'rent_hourse'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'住房贷款利息支出' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'person_tax', @level2type=N'COLUMN',@level2name=N'hourse_loan'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'赡养老人支出' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'person_tax', @level2type=N'COLUMN',@level2name=N'solatium'
GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'继续教育支出' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'person_tax', @level2type=N'COLUMN',@level2name=N'continuing_education'
GO

